Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | RetailTransaction(TR_RTL) |
LineItemGroupID (PK) | The unique identifier for this LineItemGroup within the bounds of the parent RetailTransaction. | ID_TRN_LTMGP | LineNumber | smallint | |
RetailTransactionLineItemGroupTypeCode (FK) | A code that describes a categorization of groups of line items in a RetailTransaction. e.g. Delivery, Pickup, Tray (in food service) | TY_TRN_TOT | Code | varchar(20) | RetailTransactionLineItemGroupType(TR_RTL_LTMGP_TYP) |
Description | A narrative description of the items in this LineItemGroup, or some extra processing to be performed on them. | DE_LTMGP | DescriptionNarrative | varchar(4000) | |